package com.sec.etech.org.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sec.etech.org.dto.OrgUserSyncHrsExtend;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrgUserSyncHrsExtendMapper extends BaseMapper<OrgUserSyncHrsExtend> {
    @Select("SELECT a.*,b.id_ AS etech_user_id,b.password_ AS etech_password,b.remark_ AS etech_remark,c.id_ AS create_by_user_id,d.id_ AS update_by_user_id,e.id_ AS etech_group_id FROM org_user_sync_hrs a LEFT JOIN org_user b ON a.account_=b.account_ LEFT JOIN org_user c ON a.create_by_=c.account_ LEFT JOIN org_user d ON a.update_by_=d.account_ LEFT JOIN org_group e ON a.group_id=e.code_")
    List<OrgUserSyncHrsExtend> getOrgUserSyncHrsExtentList();
}
